Skip to main content
TrustRadius
SAS Data Management

SAS Data Management

Overview

What is SAS Data Management?

A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.

Read more
Recent Reviews
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 11 features
  • Connect to traditional data sources (10)
    8.6
    86%
  • Connecto to Big Data and NoSQL (9)
    8.1
    81%
  • Integration with data quality tools (9)
    7.6
    76%
  • Simple transformations (8)
    6.1
    61%
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

8.3
Avg 8.3

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

6.7
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

6.7
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

7.9
Avg 8.2
Return to navigation

Product Details

What is SAS Data Management?

A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.

Included Data Preparation solutions streamline data workflows and execute ELT, supporting data pipelines to ingest, transform and serve high-quality data with a low-code self-service visual designer. And governance solutions help users to ensure regulatory compliance.

SAS Data Management Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.

Reviewers rate Connect to traditional data sources highest, with a score of 8.6.

The most common users of SAS Data Management are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(36)

Attribute Ratings

Reviews

(1-5 of 5)
Companies can't remove reviews or game the system. Here's why
September 11, 2020

My SAS Enterprise Data Integration Server Review

Filippo Orlando | TrustRadius Reviewer
Filippo Orlando
Advanced Analytics Manager
Unieuro S.p.A. (Retail, 1001-5000 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
The product is used by our company to meet specific needs in the analytics field, for our CRM. In our case, it's used to manage customer segmentation logics and CRM targeting. I think it is the ideal solution, but may not find it's place in other areas or projects.
Pros and Cons
  • Integrability with different data sources. The provision of native connectors is complete and there is the possibility of implementing new ones.
  • Flexibility in power sources, thanks to the connectors with the main DB and the integration of all types of formats (XML, CSV, JSON, etc.)
  • End-to-end process with the SAS suite. Products such as SAS Visual Analytics allows the visualization of the data produced, or Visual Data Mining and Machine Learning which allows you to perform advanced analysis.
  • It is a versatile product but sometimes difficult to use due to the very close link with the proprietary programming language where specific knowledge is required.
  • Compared to competitors on the market that offer the same functions for the integration perimeter, it is certainly very expensive.
  • It is very simple to use when combined with products from the SAS suite, less so it is being used stand-alone or integrated with other well-known brands.
Likelihood to Recommend
I believe that in the field of Data Integration, the SAS product is very suitable if the company uses SAS products for all the steps of the data. It is less suitable if used as a stand-alone tool. In our case, to manage customer segmentation logics and CRM targeting, it is the ideal solution.
SAS Data Management Feature Ratings
Data Source Connection (2)
80%
8.0
Connect to traditional data sources
80%
8.0
Connecto to Big Data and NoSQL
80%
8.0
Data Transformations (2)
60%
6.0
Simple transformations
50%
5.0
Complex transformations
70%
7.0
Data Modeling (5)
62%
6.2
Data model creation
50%
5.0
Metadata management
70%
7.0
Business rules and workflow
60%
6.0
Collaboration
70%
7.0
Testing and debugging
60%
6.0
Data Governance (2)
75%
7.5
Integration with data quality tools
70%
7.0
Integration with MDM tools
80%
8.0
Return on Investment
  • Implementation time to be expected due to the expertise on SAS tools and its language.
  • Complete and very powerful tool, especially combined with other SAS products.
  • Modern product always in step with the times and needs, certainly not cheap.
Alternatives Considered
The product is best when combined with the other products of the SAS suite. In particular, it's great for the preparation, analysis and display of the data if it is carried out with the products indicated above. When it is combined with products other than those of the SAS suite, the integration and solution of the issues are complex.
Support Rating
7
It is a good product, but not the best in its field. Very functional if combined and confined to the SAS world. Unnecessarily complex and expensive if outside this scope. I believe that on the market, in relation to quality/price, there are more versatile products that allow greater integration even if less powerful and performing.
Usability
6
The main negative point is the use of a non-standard language for customizations, as well as the poor integration with non-SAS systems. However, there is no doubt that it is a high-performance and powerful product capable of responding optimally to certain requirements.
Other Software Used
June 04, 2019

A great product but licenses are costly

Verified User
Consultant in Information Technology
Utilities Company, 10,001+ employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
SAS has been used by many users in our organization, mainly business and retail users for running various modeling using SAS optimizer. It allows the user a wider range of capabilities to cleanse and manipulate the data.
Pros and Cons
  • Manipulation of data
  • Interact directly with visualizations that refine analyses
  • Wide range of delivery reports
  • Licenses are very costly
  • Its not easy to move SAS users to other open source products because of the easy programming in SAS.
Likelihood to Recommend
SAS Enterprise Data Integration allows the user a wider range of capabilities to cleanse and manipulate the data. Not only can the data be pulled directly into SAS, but before it is finalized it can be transposed, graphed, or altered. Depending upon the number of use cases and business requirements, think before investing.
SAS Data Management Feature Ratings
Data Source Connection (2)
100%
10.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (5)
92%
9.2
Data model creation
100%
10.0
Metadata management
90%
9.0
Business rules and workflow
90%
9.0
Collaboration
100%
10.0
Testing and debugging
80%
8.0
Data Governance (1)
90%
9.0
Integration with data quality tools
90%
9.0
Return on Investment
  • We looked at how this tool could not only help us now but what it can do to expand our business intelligence in the future.SAS is great because they have so many different modules and products that a company can simply add capabilities as they grow their internal business intelligence division.
Alternatives Considered
SAS integration is not easy because there are various PAM related modules which require additional vendor involvement. Overall once all integrations are set up, it's a great tool and provides multiple options to users for running their model.
Other Software Used
Performance
9
It worked as expected.
Usability
9
Overall SAS is a great product and it's been in the market for decades.
Users and Roles
170
Retail, Business, Finance users
Support Headcount Required
3
SAS Administration is a must along with Unix experience.
Business Processes Supported
  • Data modelling
  • Data governance
Innovative Uses
  • Data optimizer
Future Planned Uses
  • Evaluate other alternatives to avoid license cost
Likelihood to Renew
9
Its overall support, product and cost
Support Rating
9
Its overall cost, support and product
Exceptional Examples of SAS Data Management Support
They have funded the SAS upgrade project last year.
Easy Tasks
  • SAS programming
  • API calls
  • Integration with warehouse and big data
Difficult Tasks
  • Encryption
  • Data governance
February 28, 2018

Trustworthy and Powerful

Donald Wildeboer | TrustRadius Reviewer
Donald Wildeboer
Information Analyst
Agriculture Financial Services Corporation (Financial Services, 501-1000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
SAS Data Integration Studio is being used for one view of all our data across the organization. Pulling from our Oracle and SQL Servers the data is described in a fashion that users can know what they are looking at with only a little bit of effort. It also pulls from our major vendors' platforms, pulling both the data or metadata from their systems.
Pros and Cons
  • With SAS Data Integration Studio it doesn't matter to users where the data is originally from it all is presented in a consistent manner.
  • The SAS Data Integration Studio is fairly reliable it usually works well.
  • The visual design of reports our users even describe as fun.
  • Sometimes parts of the data are not available, although this is generally because it is connected to so many different systems.
  • Price, it's not the cheapest software, however the value for dollars spent does seem to be good.
  • Sometimes all the different systems and platforms and folders and so forth get a bit overwhelming for new users.
Likelihood to Recommend
When data is in a system that needs a complex transformation to be usable for an average user. Such tasks as data residing in systems that have very different connection speeds. It can be integrated and used together after passing through the SAS Data Integration Studio removing timing issues from the users' worries. A part that is perhaps less appropriate is getting users who are not familiar with the source data to set up the load processes.
SAS Data Management Feature Ratings
Data Source Connection (2)
100%
10.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
90%
9.0
Simple transformations
80%
8.0
Complex transformations
100%
10.0
Data Modeling (5)
80%
8.0
Data model creation
80%
8.0
Metadata management
80%
8.0
Business rules and workflow
90%
9.0
Collaboration
80%
8.0
Testing and debugging
70%
7.0
Data Governance (2)
90%
9.0
Integration with data quality tools
90%
9.0
Integration with MDM tools
90%
9.0
Return on Investment
  • We have more users who can connect to the many different data sources.
  • Our users do have existing SAS programming knowledge and that can carry over.
  • Business functions are starting to rely on SAS Data Integration Studio work product shortly after introduction.
Alternatives Considered
Because SAS Data Integration Studio is the third party it seems to work equally well with all our systems. That is to say that it doesn't really work better with Microsoft or Oracle but really just seems to work equally well with all of them. It has a very powerful back-end that allows us to transform and load our data quickly and efficiently programmer time wise.
Other Software Used
September 22, 2017

Access Your Data

Nikardi Jallah | TrustRadius Reviewer
Nikardi Jallah
Epidemiologist
Maryland Department of Health and Mental Hygiene (Health, Wellness and Fitness, 51-200 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
I currently use SAS/Access to analyze data coming in from the state level Behavioral Health Risk Factor Surveillance System and the Youth Risk Behavior Survey. I focus on tobacco data and SAS is extremely important when looking at this data. I use SAS STAT to analyse the data using survey procedures. Because BRFSS and YRBS are complex surveys I must use the survey procedures in SAS to get weighted frequencies, means and estimates. It is extremely easy to use SAS for these analyses, because the procedures are pretty repetitive. However, I do wish that the strata, weight, and cluster variables did not have to be typed with each procedure done. When using STATA or SPSS these variables are entered once, and the weighted results are automatically given when writing procedure. No need to enter them in for each. However, I am more comfortable with SAS coding and really like that it is user friendly. The online support for SAS is wonderful as well.
Pros and Cons
  • SAS/Access is great for manipulating large and complex databases.
  • SAS/Access makes it easy to format reports and graphics from your data.
  • Data Management and data storage using the Hadoop environment in SAS/Access allows for rapid analysis and simple programming language for all your data needs.
  • SAS/Access coding is not as simple as SQL query language. SAS/Access requires the user to have prior knowledge of SAS coding and data-set manipulation.
  • SAS/Access support is not as good as Base SAS support, there is not much help if you want to do a specific format or data merge with your datasets.
  • SAS/Access is a bit expensive compared to SQL, but if you already have Base SAS it is not as expensive.
Likelihood to Recommend
SAS/Access is well suited for companies who need to manipulate and analyze large databases and data-sets. It does the same thing as SQL, and if you already know basic SAS coding it is easier to pick up. SAS/Access works well with analyzing data from multiple data-sources at once, including large databases stored in external and virtual environments like Hadoop. Data can be easily reassembled from relational databases for use by the user. SAS/Access is not necessary if you are only pulling data from one database that you have the physical file for.
SAS Data Management Feature Ratings
Data Source Connection (2)
95%
9.5
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
85%
8.5
Simple transformations
80%
8.0
Complex transformations
90%
9.0
Data Modeling (5)
56%
5.6
Data model creation
70%
7.0
Metadata management
80%
8.0
Business rules and workflow
70%
7.0
Collaboration
60%
6.0
Testing and debugging
N/A
N/A
Data Governance (2)
80%
8.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
80%
8.0
Return on Investment
  • SAS/Access has worked so that people do not have to be retrained in SQL.
  • We have more access to all relational and un-relational databases.
  • However, not many people are familiar with SAS/Access making it hard for collaboration.
Alternatives Considered
SAS/Access can work well with MySQL. There are some coding differences between the two, for example how missing values are handled or rules for variable names. MySQL has simpler coding, but if you are familiar with Base SAS, it is not too difficult to learn. With SAS/Access the user has more freedom with formatting the databases from the data source that they are pulling from. Also, modeling and analysis is easier in SAS. SQL does not do much with graphics or modelling.
Other Software Used
October 22, 2013

DataFlux - a good choice for SAS-shops

Robert Goodman | TrustRadius Reviewer
Robert Goodman
Director of Business Intelligence & Analytics
Georgetown University (Information Technology and Services, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Pros and Cons
  • dfPower Studio connects to virtually any data source, and any dfPower Studio user in any department can use dfPower Studio to profile, cleanse, integrate, enrich, monitor, and otherwise improve data quality throughout the enterprise. dfPower Architect, an innovative job flow builder, enables users to build complex management workflows quickly and logically.
  • DataFlux Integration Server supports the ability to run batch dfPower Studio jobs in a client/server environment.
  • DataFlux Integration Server for SAS additionally enables allows SAS programs to invoke DataFlux batch jobs from a SAS program and allows SAS programs to call a business service that was designed in the dfPower Studio client environment.
  • DataFlux handled all of our data integration needs. It could be considered pricey when compared to Microsoft's bundled SSIS product.
Likelihood to Recommend
Return on Investment
  • Complex data integration.
  • SAS integration.
Likelihood to Renew
10
We are happy with the software and its functionality. As a SAS-shop, DataFlux is a logical choice for complex data integration.
Return to navigation